package com.example.demo.mapper;

import java.util.List;

import com.example.demo.dto.FeedbackDto;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.Select;

public interface FeedbackMapper {

	@Select("select zname,fid,fmessage,fstate,ftitle from feedback,main_theater where feedback.zid=main_theater.zid and fstate='未处理'")
	List<FeedbackDto> getAllfeedback();

	@Update("update feedback set fstate='已处理' where fid=#{fid}")
	int solveFeedback(int fid);

}
